Google Spreadsheet Post #1181
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. May 08, 2013
user Monica Rampani (https://productforums.google.com/forum/?hl=en#!category-topic/docs/spreadsheets/MCA3o4R_8YM)
Using Match and indexing another value within the same column
Ok, so I have a formula that uses a combination of Index and Match to return a value withing the same row of what I'm matching. The formula I use is =INDEX('Battery Corp Record'!$V$2:$V$2148,MATCH(A3,
I want to edit this formula so that when it finds the match, it indexes something within that column it found the match in instead of the row. Here's my setup if it helps
Sheet Name: Master List
FA Code
10005053
10005059
10005062
10005063
10005064
10005100
(ETC....)
2 Sheet Name: Vendor Billing PO's
2/22/2013 3/4/2013 3/11/2013 3/19/2013 <-----row 6 and the value I want to return when a match is found
10005182 10127974 10082588 10147514
10006361 10082604 10122633 10116097
10006369 10083519 10082598 10082202
10029993 10083505 10082676 10122645
10042959 10081740 10112007 10142150
10092793 10082220 10082610 10138669
10092814 10083512 10083532 10111204
10124127 10081787 10145416 10136179
What I need to do is put a formula in column B of the master list where it matches the FA code in column A, looks for it in the Vendor Billing sheet and returns the date of the column it's found in. The date columns are row 6.
Thanks in advance to any help anyone can provide, it is much appreciated!
---
Sure thing Yogi! See spreadsheet for the questions you asked. I highlight yellow were I need formula and expected results and explanation are in columns D&E.
-----------------------------------------------------------------------------------------------------------------------
let us have a look at the following
No comments:
Post a Comment