How to use results of VLOOKUP in calculation

I've been lurking for a while and I've found so much help here. You folks are really something. I'm up against something I can't figure out. I’ve been searching for help with what I want to do and have come up dry. Below is an outline of whqt I want to do. Any help will be appreciated.

· Worksheet1 has data.
· Worksheet2 uses VLOOKUP back to worksheet1 for data to populate cells on worksheet2. The VLOOKUP
command below returns a value of 126 to cell C6.
· I want to use the number result of the VLOOKUP in C6 (126) as part of a calculation for another cell. In this
case, cell D6 is keyed in. I want to get the result of =(N(D6)-N(C6)) and put it in cell F6. To further
complicate things, if C6 is blank, I want F6 to be blank.


VLOOKUP formula that returns a value of 126 from worksheet1 and puts it in cell C6 on worksheet2. It also returns a blank if there is a blank on worksheet1.

=IF(ISNA(VLOOKUP(A6,Pivot_Table!$A$3:$D$36,3,0))+(VLOOKUP(A6,Pivot_Table!$A$3:$D$36,3,0)=""),"",VLOOKUP(A6,Pivot_Table!$A$3:$D$36,3,FALSE))

Welcome to the forum TigerCat,

If I'm reading correctly, in F6 enter =IF(C6="","",D6-C6)

I don't know why you are using the N() function! Do you sometimes get a non-numeric value, and need to force 0?

I hope this helps, please let me know!

Regards,

David

Please remember, your request is clearer if you attach a sample workbook.
- Click on Go Advanced and click on the Paper Clip.
When you reply please make it clear WHO you are responding to by mentioning their name.
If this has been of assistance, please advise. A little thanks goes a long way.
- Please click on the *Add Reputation button at the bottom of helpful responses.
Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

Well, I certainly made this more complicated than necessary. Your formula suggestions really helped. The idea behind the multiple VLOOKUPs was to give me back a 0 if there was a 0 there and a blank instead of #N/A if there was no record for that employee or contractor in worksheet1. I've learned tons about formulas, macros, and VLOOKUP with this workbook but it's obvious I have much more to learn. I really appreciate your help and this forum is wonderful.