Using Wildcards in Find & Replace

Originally Posted by uhcord98

I'm doing a search simular to this

=VLOOKUP(D*,Sheet2!A*:B*,2,FALSE)

and I want it replaced with this

=VLOOKUP(D3,Sheet2!A1:B42,2,FALSE)

HOWEVER when I do the find & replace I don't want it to change whatever the current value is to D3 I want it to stay as whatever it was already....so how do I exempt the "D" value from the search??

Hi,

is D required, or can you succeed with Replace ,Sheet2!A*:B*,2,FALSE) with ,Sheet2!A1:B42,2,FALSE)

---

Originally Posted by uhcord98

I'm doing a search simular to this

=VLOOKUP(D*,Sheet2!A*:B*,2,FALSE)

and I want it replaced with this

=VLOOKUP(D3,Sheet2!A1:B42,2,FALSE)

HOWEVER when I do the find & replace I don't want it to change whatever the current value is to D3 I want it to stay as whatever it was already....so how do I exempt the "D" value from the search??

Hi
Does this work

=VLOOKUP(D?,Sheet2!A?:B?,2,FALSE)

Originally Posted by uhcord98

"D" is required for the formula to work, however I don't want ANY of that part of the formula to be replaced when I do the find command because the D values are in consecutive order, D1, D2, D3, because those are the cell that is being looked up and the A1:B42 will always be the same because it's the range table excel is looking in to find the result.

That was not my question.

Can you succeed with Replace ,Sheet2!A*:B*,2,FALSE) with ,Sheet2!A1:B42,2,FALSE)
or are there similar formula working on a column that is not D?

---