im having trouble getting VLOOKUP to do this

[MRChampion]

i just want it to find the right part id (F - Number) and put the yes or no from the Input page, in the box on the Info page.tester.xlsx

[AliGW]

In cell C6, dragged down:

=VLOOKUP($B6,Input!$E$3:$K$12,2)

In cell D6, dragged down:

=VLOOKUP($B6,Input!$E$3:$K$12,4)

In cell E6, dragged down:

=VLOOKUP($B6,Input!$E$3:$K$12,6)

[David A Coop]

I had the same answer as AliGW, but then I thought you might want one formula for all cells, so i came up with this:

=VLOOKUP($B6,Input!$E$3:$K$12,MATCH(C$2,Input!$F$1:$K$1,0)+1,0)

Just pop it in cell C6, and copy down and across.

I hope this helps, please let me know!

Regards,

David


- Please click on the *Add Reputation button at the bottom of helpful responses.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

[azumi]

or, put in C6, and copied down and cross as necessary

=INDEX(Input!$F$3:$K$12,MATCH($B6,Input!$E$3:$E$12,0),MATCH(C$2,Input!$F$1:$K$1,0))

[MRChampion]

ok that works awesome. now if there was a f- number on the info page thats not on the table. how do i get to show nothing instead of the N/A i mean a 0 would work

[Pepe Le Mokko]

Try =IFERROR(your_formula,0)

You can replace the 0 with "" but to me it's bad practice, as "" is a text string

Eventually hide the 0 via Excel Options