If function to match cols and return value of another col

H

Haz

Hi,

Is it possible to use this function below, to then return the value of the
matching cells in Col I. For example if there is a direct match for A2 in Col
E, then in either this cell of another return the value in col I relating to
Col E?

IF(ISNA(MATCH(A2,E:E,0)),"no match","match")
 
P

PCLIVE

This is untested, but try this:

=IF(ISNA(MATCH(A2,E:E,0)),"no match",INDIRECT("I" & MATCH(A2,E:E,0)))

HTH,
Paul
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Index/Match vs VLookup? 4
cell returning totals of 2 cols+ sending this value to another col 5
Index/Match modification maybe? 2
Calculation Speed (Index/Match vs Vlookup)? 6
Lookup value and return column offset value 5
Compare & align 2 cols of Employee Names in sorted alpha order withVBA 4
Search range, find value in another col in corresponding row 3

Top