information from Col A:A

[Steved]

Hello from Steved

I've got 2 worksheets

The sheets are called "Duties Mon-Fri" and "Mon-Fri"

=IF(ISNA(VLOOKUP($B$2:$C$2,'Duties
Mon-Fri'!$C$2:$E$4994,3,FALSE)),0,VLOOKUP($B$2:$C$2,'Duties
Mon-Fri'!$C$2:$E$4994,3,FALSE))

The above works perfectly because I copied the information into Col E:E

Question please How do I get the information from Col A:A

I Thankyou.

 

[Dave Peterson]

I would think that you'd only use a single cell as that first parm's value:

=IF(ISNA(VLOOKUP($B$2,'Duties Mon-Fri'!$C$2:$E$4994,3,FALSE)),0,
VLOOKUP($B$2,'Duties Mon-Fri'!$C$2:$E$4994,3,FALSE))

But if you want to bring back the value in column and match the value in column
B:

=index('duties mon-fri'!$a$2:$a4994,match($b$2,'duties
mon-fri'!$b$2:$b$4994,0)))

You may want to check for an error first:
=if(isna(match($b$2,'duties mon-fri'!$b$2:$b$4994,0)),0,....

Debra Dalgleish has lots of notes:
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://www.contextures.com/xlFunctions03.html (for =index(match()))
and
http://contextures.com/xlFunctions02.html#Trouble

 

[Steved]

Thankyou

I would think that you'd only use a single cell as that first parm's value:

=IF(ISNA(VLOOKUP($B$2,'Duties Mon-Fri'!$C$2:$E$4994,3,FALSE)),0,
VLOOKUP($B$2,'Duties Mon-Fri'!$C$2:$E$4994,3,FALSE))

But if you want to bring back the value in column and match the value in column
B:

=index('duties mon-fri'!$a$2:$a4994,match($b$2,'duties
mon-fri'!$b$2:$b$4994,0)))

You may want to check for an error first:
=if(isna(match($b$2,'duties mon-fri'!$b$2:$b$4994,0)),0,....

Debra Dalgleish has lots of notes:
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://www.contextures.com/xlFunctions03.html (for =index(match()))
and
http://contextures.com/xlFunctions02.html#Trouble