index match
Anthon wrote:
A B C D
ROW 5 1 65 6 56
ROW 6 2 100 7 41
ROW 7 3 34 8 32
ROW 8 4 6 9 43
ROW 9 5 8 10 5
I have 4 columns as above in one sheet, I want to match the numbers 1 to 10
and return the values in the column matching the number in another sheet as
below. Please note, the above format changes on a daily basis as it comes
from a web query e.g tomorrow there might only be 8 numbers, in which case 5
in A9 will move to C5 and A9 and C 9 will then be blank.
A B
ROW 5 1 65
2 100
3 34
4 6
5 8
6 56
7 41
8 32
9 43
Row14 10 5
The formula should be in B5 through B14 , is this possible? Thanks. Anthon.
So are you just trying to look up the value in column B of the first
table and place it in the second table based on matching values in
columns A? (What is the significance of columns C & D in table 1?)
in table2!B5,
= VLOOKUP (A5, table1!$A:$A, 2, false)
fill down.
or, since you say values might be missing the the first table,
= If (ISNA(VLOOKUP (A5, table1!$A:$A, 2, false), "", VLOOKUP (A5,
table1!$A:$A, 2, false))
|