need some information and Help with Vlookup Please.

[Ausikenoath]

have posted my workbook on google for any one to assist me with my search for an easy answer as i am stuck badly trying to figure out how to appy VLOOKUP to the second to last page of the workbook, the information needed for the vlookup is on the last page and i have added the cells where i need to figure out how to properly and EASILY insert the correct formula for these problems.

Hope some one will assit me with this

Thanks in advance

Peter

Ausikenoath.

here is the google link


https://docs.google.com/spreadsheet/ccc?key=0AvIZpMAnctBDdHpUc2NRUWZLNTFseURyaXVqN1A3RWc

 

[NARAYANK991]

Hi ,


Can you check out the following worksheet :


https://docs.google.com/spreadsheet/ccc?key=0AkKMpuzr3MTVdGcyLWhCaEpFbjlMS2hKb0hHMHA2bnc


Narayan

 

[SirJB7]

Hi, Ausikenoath!


Give a look at this file: http://dl.dropbox.com/u/60558749/need%20some%20information%20and%20Help%20with%20Vlookup%20Please%20-%20Playboxgames_Part6_12%20%28for%20Ausikenoath%20at%20chandoo.org%29.xls


I've only found cells to use VLOOKUP function in sheet "Customer Quotes". Please see cells C6:C10, E6:E10, F12:F13.

I modified cell C16 formula, changed the test condition from "F14>0" to "F13=0".

I created a new block for Freight Charges.

For the VLOOKUP functions, I defined 3 named ranges, see Formula tab, NameAdmin icon. It's not necessary but it's easier to code. For example instead of writing VLOOKUP(B6,Sheet1!$A$3:$C$10,2,FALSE) I can write VLOOKUP(B6,GamesTable,2,FALSE).


Hope it aids you.


Regards!

 

[SirJB7]

@NARAYANK991

Hi!

Sorry, I left the topic open while watching TV. I didn't see your reply.

Regards!

 

[NARAYANK991]

Hi SirJB7 ,


Not at all. Two answers are better than one !


Narayan

 

[Faseeh]

Hi SirJB7, NARAYANK991,


Might these formulas work as well, i hope you guys donot mind this intruption:


In cell C6 : =IF(ISBLANK($B6),"",VLOOKUP(B6,Sheet1!$A$3:$C$10,2)) Drag down

In cell E6 : =IF(ISBLANK($B6),"",VLOOKUP(B6,Sheet1!$A$3:$C$10,3)) Drag down

In Cell D12: =VLOOKUP(F11,Sheet1!E3:F6,2)


Faseeh

 

[SirJB7]

@<The two guys who're looking over my shoulder>

Hi, both!

Once more time?



Regards!

 

[Ausikenoath]

thank you both this should help me greatly.