returing data from a different table

[DEEARO]

Hi all,

thank you for your help in advance.


I trying to get information on tab WHP for different sites from WHP data.

[Bernie Deitrick]

In E7 of WHP, use the formula

=VLOOKUP($C7,'WHP DATA'!$B:$E,COLUMN(B$1),FALSE)

and copy to the other five cells.

[Fluff13]

Another option fr 365
In E7 copied down only

Please Login or Register  to view this content.

[DEEARO]

This worked, but I would like to understand how it works. I understand how Column(b$1) works as that cell is blank.

[DEEARO]

In E7 of WHP, use the formula

=VLOOKUP($C7,'WHP DATA'!$B:$E,COLUMN(B$1),FALSE)

and copy to the other five cells.

------
This worked, but I would like to understand how it works. I do not understand how Column(b$1) works as that cell is blank.

[Bernie Deitrick]

My use of COLUMN() is just a shortcut that makes using one formula possible.

COLUMN just returns a number. This formula

=VLOOKUP($C7,'WHP DATA'!$B:$E,COLUMN(B$1),FALSE)

is the same as

=VLOOKUP($C7,'WHP DATA'!$B:$E,2,FALSE)

When copied to the right, it becomes

=VLOOKUP($C7,'WHP DATA'!$B:$E,COLUMN(C$1),FALSE)

etc., which is the same as

=VLOOKUP($C7,'WHP DATA'!$B:$E,3,FALSE)

I could have told you to use this in the first cell

=VLOOKUP($C7,'WHP DATA'!$B:$E,2,FALSE)

but then, when copied to the right, you would have had to edit the 2 manually.