| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
lookup with 2 criteria
I'm working on utility data for a chain of stores. I need to lookup an
account number based on both facility # and meter # b/c some facilities have multiple meters. This formula only matches the account # and does not cross reference meter #. =VLOOKUP(A96,Gaps!$A$8:$D$2102,3) A96 = fac # on sheet 2 Gaps!A8:D2102 = where data is kept On gaps page, fac # is column A, account # is column C, meter # is column D Thanks in advance for any words of wisdom! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i get mutiple values using vlookup in excel, lookup value . | Excel Discussion (Misc queries) | |||
| SUMIF with only one criteria cell within range | Excel Discussion (Misc queries) | |||
| formula that meets two criteria and sums? | Excel Discussion (Misc queries) | |||
| Print cells that meet conditional formatting criteria | Excel Discussion (Misc queries) | |||
| HELP -- probably a LOOKUP problem | Excel Discussion (Misc queries) | |||
Threaded Mode
