CODEWITHSUNDEEP
excelexcel-2013
howzat
howzat

Reputation: 49

Excel: How to have an IF function return the value of the cell from another sheet

This is sort of a carry on from my previous question. I have a sheet named Car Search which returns the details of a car from the Raw Data sheet when the Car ID is entered (see image 1).

I would like the Notes column to return what is in the Raw Data sheet in that specific cell. This is dynamic; so if the cell was F561, then I would like it to return that exact cell.

So for example, when I enter the Car ID '2613' into the Car Search sheet, I would like column E5 to return the value of the specific cell in the Raw Data tab. (Currently, that cell is F5 which is 'here2').

Is there a formula that can do this? Or am I missing something in the current formula?

My current formula is this: =IF(INDEX('Raw Data'!E:F,MATCH($B$3,'Raw Data'!A:A,0),MATCH(E2,'Raw Data'!1:1,0))="","")

Car Search sheet Raw data sheet

Any help appreciated :)

Upvotes: 0

Views: 1935

Answers (2)

Brian
Brian

Reputation: 2108

Try this untested formula:

=""&INDEX('Raw Data'!$F:$F,MATCH($B$3,'Raw Data'!$A:$A,0))

Upvotes: 1

Ulli Schmid
Ulli Schmid

Reputation: 1167

Your Index() formula is searching within E:F, but the column index you supply is actually identical with the column id. So change this to A:Z.

Also, I'd suggest some "$" since it looks like you wish to drag this formula:

=""&INDEX('Raw Data'!$A:$Z,MATCH($B$3,'Raw Data'!$A:$A,0),MATCH(E$2,'Raw Data'!$1:$1,0))

Wrapping it with IF(Result="","",Result) is kind of redundant - it serves no function.

Upvotes: 1

Related Questions