vlookup answers

  1. H

    2 vlookup a good excel power

    In 1 workbook I am doing vlookup as =VLOOKUP(B8,DOLLAR!$A$10:$AB$202,28,0 if ws named EURO in cell F8. There is 1 more ws named POUND. In that E9:E201 either has "" (null thr' formula) or value. Answer: In F8 of EURO, I want the formula to give me answer provided the corresponding vlookup in...
  2. J

    How to Join (2 VLOOKUP Formulas together) to get 1 result?

    Hello, I'm trying to see if there is a Formula to look up (2 Vlookup formulas to get 1 result)? And since I there isn't a place for me to attach a .xlsm or .xls file to show you. I'll have to explain below. Example: I have a Tournament of 20 teams, and each Team plays each other and I have the...
  3. B

    VLOOKUP - 2 Criteria

    <TABLE style="WIDTH: 158pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=210 border=0 x:str><COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 62pt; mso-width-source: userset; mso-width-alt: 2998" width=82><TBODY><TR style="HEIGHT...
  4. E

    How to populate cell based on multiple criteria from another workbook

    :confused: My Problem is as follows: In Workbook 1 I will enter two pieces of data. In cell A1 I will enter (County Name) and In cell B2 (Plan Number). In Workbook 2 I have a database as follows: Col1=PlanNumber Col2=County Col3=Value. I need to populate cell B3 in workbook 1 with matching...
  5. V


    =IF(VLOOKUP(T15,'Ex Clear'!$S$2:$S$2001,1,FALSE)=Govi!T15,IF(VLOOKUP(Govi!S15,'Ex Clear'!$U$2:$U$2001,1,FALSE)=Govi!S15,IF(VLOOKUP(Govi!B15,'Ex Clear'!$W$2:$W$2001,1,FALSE)=Govi!B15,IF(VLOOKUP(Govi!A15,'Ex Clear'!$X$2:$X$2001,1,FALSE)=Govi!A15,VLOOKUP(T15,'Ex Clear'!$S$2:$V$2001,4,FALSE),0))))...
  6. C

    Lookup #NA

    I am struggling to find a solution to a formula returning #NA. I understand that the cell reference insertion is the issue as I can change it to a numerical value and the formula works perfectly. However, as the cell value will change regularly, its actual value cannot be inserted. current...
  7. K

    Question: lookup values based on multiple criteria, how?

    I use Excel 2003. Now I have a data sheet in my workbook like this: <TABLE style="WIDTH: 414pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=551 border=0 x:str><COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 32pt; mso-width-source: userset; mso-width-alt: 1572"...
  8. D

    Array issue

    Hello everyone - here is my situation. I have one tab, which is a data dump, a second tab that has static information, as well as a vlookup to the data dump tab, and a third tab I am using for the summary... I am trying to count the number of time something has been reviewed, which will show...
  9. G

    Vlookup finding certain answers

    Hi I'm trying to do a Vlookup with a ref no. 91903 to 91903 this is the easy part for me but i have multiple ref no but the answers i'm looking for are different. in the place its looking up its set out like 91902 3rd 91903 1st 91903 nontime 91903 2nd 91903...

Some videos you may like

This Week's Hot Topics