Thread: index match
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default index match

10 formulas, wherever you want them:

=A5
=A6
=A7
=A8
=IF(A9="",C5,A9)
=IF(A9="",C6,C5)
=IF(A9="",C7,C6)
=IF(A9="",C8,C7)
=IF(A9="","",C8)
=IF(A9="","",C9)

You could do it with one formula, but it would be more complex and harder to
understand.

HTH,
Bernie
MS Excel MVP


"Anthon" wrote in message
...
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.