Wednesday, May 8, 2013

yogi_Match FA_Code In Vendor Billing POs Sheet And Extract The Invoice Date From Therein


                                          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,'Battery Corp Record'!$B$2:$B$2148,0),1).

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