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.
Configuration: Windows Vista Safari 532.0
Add information if seperate cells match Check format of date dd/mm/yyyy in if statement vb in excel cell Example change font in a if statement in excel Excel if statement flashing How to disable macro buttons using if statements in excel How to increase number of conditions in if statement If statement how to find text in a range excel If statement in excel to get rid of '0' If statement in macro excel If statement is true use a formula If statement return excel If statements in excel If statements with and excel macros Increasing numbers with if statement in excel Multiple values in if statement Open office if statement spreadsheet guide Spreadsheet if statements with time Transfer information from one mac to another if motherboard is out.