Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 7th 04, 05:19 AM
Dylan Moran
 
Posts: n/a
Default VLOOKUP trouble .. HELP!

Hi I am a novice in excel. Sorry. I have tried the help and this forum but
just am not getting Vllokup functions.

I have a spreadsheet with the following values (example)

Column A

Allocated
Not Allocated
Restricted
Quarantined

I want to be able to do similar to an if statement where I can lookup the
value in colum A and if "Allocated" put the value "Held" in column B but if
"Not Allocated" put the value "Spare" in Column B.

I hope this makes sense. Your help is appriated.


Dylan Moran - Melbourne Australia

  #2   Report Post  
Old December 7th 04, 05:25 AM
Dylan Moran
 
Posts: n/a
Default

P.S. I also want a vlaue of "nothing" for if it doesn't find the value in the
lookup.
Or I want like an ELSE statement for the other things.

"Dylan Moran" wrote:

Hi I am a novice in excel. Sorry. I have tried the help and this forum but
just am not getting Vllokup functions.

I have a spreadsheet with the following values (example)

Column A

Allocated
Not Allocated
Restricted
Quarantined

I want to be able to do similar to an if statement where I can lookup the
value in colum A and if "Allocated" put the value "Held" in column B but if
"Not Allocated" put the value "Spare" in Column B.

I hope this makes sense. Your help is appriated.


Dylan Moran - Melbourne Australia

  #3   Report Post  
Old December 7th 04, 07:25 AM
Frank Kabel
 
Posts: n/a
Default

Hi
try
=IF(COUNTIF(A1:A4,B1),"Match","")

where B1 conatins the value you want to lookup

--
Regards
Frank Kabel
Frankfurt, Germany

"Dylan Moran" schrieb im
Newsbeitrag ...
Hi I am a novice in excel. Sorry. I have tried the help and this

forum but
just am not getting Vllokup functions.

I have a spreadsheet with the following values (example)

Column A

Allocated
Not Allocated
Restricted
Quarantined

I want to be able to do similar to an if statement where I can lookup

the
value in colum A and if "Allocated" put the value "Held" in column B

but if
"Not Allocated" put the value "Spare" in Column B.

I hope this makes sense. Your help is appriated.


Dylan Moran - Melbourne Australia




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Vlookup finds a blank, but returns a zero - HELP! flummoxed Excel Discussion (Misc queries) 6 January 18th 05 03:15 PM
VLOOKUP help SamUK Excel Worksheet Functions 8 November 22nd 04 12:27 AM
carrying a hyper link when using the vlookup function mike Excel Worksheet Functions 1 November 19th 04 03:49 AM
VLOOKUP not working Scott Excel Worksheet Functions 3 November 12th 04 08:06 PM
Using Cell references in VLookUp JonWilson631 Excel Worksheet Functions 1 November 4th 04 02:49 AM


All times are GMT +1. The time now is 12:55 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017