ExcelBanter - matching cells and transfering data

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - matching cells and transfering data (https://www.excelbanter.com/excel-worksheet-functions/125801-matching-cells-transfering-data.html)

Hurler99

matching cells and transfering data

I'm hoping there is an Fx function for this.

Col A Col B Col F Col G
(data) (result) (data) (data)

Multiple rows.

I want to compare individual cells in Col A to the range of cells in Col F,
and if it finds a match, I want the corresponding G row to copy to Col B

I think I know the first part of the formula =IF(A2=$F$2:$F$10, ????,"")

It's the ???? I can't seem to formulate.

Dave F

matching cells and transfering data

=IF(NOT(ISERROR(LOOKUP(A2,F2:F10))),G2,"")
--
Brevity is the soul of wit.

"Hurler99" wrote:

I'm hoping there is an Fx function for this.

Col A Col B Col F Col G
(data) (result) (data) (data)

Multiple rows.

I want to compare individual cells in Col A to the range of cells in Col F,
and if it finds a match, I want the corresponding G row to copy to Col B

I think I know the first part of the formula =IF(A2=$F$2:$F$10, ????,"")

It's the ???? I can't seem to formulate.

Teethless mama

matching cells and transfering data

IF(ISERROR(VLOOKUP(A2,$F$2:$G$10,2,0),"",VLOOKUP(A 2,$F$2:$G$10,2,0)))

"Hurler99" wrote:

I'm hoping there is an Fx function for this.

Col A Col B Col F Col G
(data) (result) (data) (data)

Multiple rows.

I want to compare individual cells in Col A to the range of cells in Col F,
and if it finds a match, I want the corresponding G row to copy to Col B

I think I know the first part of the formula =IF(A2=$F$2:$F$10, ????,"")

It's the ???? I can't seem to formulate.

All times are GMT +1. The time now is 01:19 PM.