VBA Match Cells, Copy Adjacent Cells

[Lelewiwi]

Hi all - I've been searching for days for a solution and have yet to find one that works. Doesn't necessarily need to be VBA, but I think it has to be as formula's don't seem to work. I have 2 sheets "Split Request" and "Hidden".

Split Request has account numbers in cells E9:E47. These are in numerical order.
Hidden has account numbers in column A. These are not necessarily in numeric order.

I need something that will search Hidden, Column A for a matching account number from Split Request E9:E47. If a match is found, it should copy the adjacent cell from Column B to the adjacent cell of the account number on Split Request, column F.

Thanks so much for the help!

 

[dreid1011]

Perhaps this:

=XLOOKUP(E9,Hidden!$A$1:$A$39,Hidden!$B$1:$B$39,,0)

 

[Lelewiwi]

Perhaps this:

=XLOOKUP(E9,Hidden!$A$1:$A$39,Hidden!$B$1:$B$39,,0)

I get an #N/A

 

[dreid1011]

I get an #N/A

For one or more lines or all of them?

 

[Lelewiwi]

For one or more lines or all of them?

All of them. And before you ask, they are all formatted the same.

 

[dreid1011]

All of them. And before you ask, they are all formatted the same.

That may have been my next question.... But since you've confirmed they are the same, would you mind posting a sample of the account numbers that I may test on?

 

[Lelewiwi]

That may have been my next question.... But since you've confirmed they are the same, would you mind posting a sample of the account numbers that I may test on?

I'm not allowed to download the add on, so screen shots will have to do.

 

[dreid1011]

Could you copy the formula from F9 exactly as you have entered it?

 

[Lelewiwi]

I copied exactly what was written above:

=XLOOKUP(E9,Hidden!$A$1:$A$39,Hidden!$B$1:$B$39,,0)

 

[Fluff]

How about

=XLOOKUP(E9+0,Hidden!$A$1:$A$39,Hidden!$B$1:$B$39,,0)