Brain stopped working

[SFCChase]

Hoping for some help...I've been staring at my worksheet for quite a while and can't for the life of me figure out what's going wrong.

I have worksheet with 2 tabs (Attendance and OML)

My Attendance tab has a list of names from D4:D21
Next to the names is an attendance % from E4:E21

On my OML list I have the same list of names from D3:D20
The order of my OML list is subject to change based off other factors. I'm looking for a formula (to put in 'OML E3:E20) that will search the Attendance Tab for the name on the OML tab and return the corresponding attendance %. It needs to be able to apply to whatever name it sees on the OML tab as the OML order changes

Thanks in advance!

 

[KennyGreens]

Hi there, I believe you are looking for something like this:

=VLOOKUP(D3, Attendance!$D$4:$E$21, 2, FALSE)

 

[SFCChase]

I tried a couple Lookup formula's yesterday and it keeps giving me a #NAME error.

 

[SFCChase]

actually it's giving me a #REF error....could this be because the attendance % on the attendance tab is based off a formula and not an actual number?

 

[KennyGreens]

I tried a couple Lookup formula's yesterday and it keeps giving me a [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=NAME]#NAME [/URL] error.

#NAME error I believe only appears from Lookup formulas when the syntax is incorrect. Please double check your formula. I just tested out the formula and it worked fine for me.

 

[SFCChase]

got the #NAME error figured out....for some reason it cut the E off my FALSE in the formula....but i'm still getting the #REF error

Any suggestions?

 

[SFCChase]

bump

 

[Indystick]

A #REF error means that the lookup cannot match your lookup value to the lookup array. If you're using VLOOKUP, then your lookup array is the first column of your table array as defined in the second argument of your VLOOKUP function.. Two possible sources of error:

1. Your table array is defined incorrectly to not include the column with the names in it.
2. You have a typo, extra space, or some other element in your name values that is causing the match to fail.

Good luck.