Pulling information with an if statement

Closed

cliffmid Posts 3 Registration date Wednesday September 30, 2009 Status Member Last seen October 1, 2009 - Oct 1, 2009 at 10:35 AM
cliffmid Posts 3 Registration date Wednesday September 30, 2009 Status Member Last seen October 1, 2009 - Oct 1, 2009 at 11:18 AM

Hello, I have three columns: a1:a10, numbers 1-10, b1:b10, descriptions, C1:c10, dollar amounts for b1:b10. I use a random number (=randombetween(1,10) to generate a number for a1:a10. Now, I would like to have excel take the random number, match it to the appropriate number in a1:a10, and display the appropriate description and cost (columns b and c) in e1. Can you help? Thanks in advance.

Pulling information with an if statement
Fenix internet on bank statement - Guide
An if statement nested within another if statement will produce how many possible results? - Guide
Excel if statement - Guide
Application for bank statement sbi - Guide
Vba case statement with string - Guide

1 response

Answer 1 / 1

cliffmid Posts 3 Registration date Wednesday September 30, 2009 Status Member Last seen October 1, 2009
Oct 1, 2009 at 11:18 AM

Thanks for your attention. I was able to get it to work using vlookup. Much simpler and faster

Similar discussions

Removing " false" value in "IF"

Need help to remove FALSE from cell

removing false in excel

Similar discussions

Subscribe To Our Newsletter!