Very simple formula needed!

[nicholes]

i want to fill data in credit account of my customer automatically when his name is entered
for example my customer name is "A" so i use this formula
i make a helper sell in which i put cutomer name "A" in L1 so here is my formula

=IF(B3:B13=$L$1,A3:A13,"")



i have got this simple formula but it leaves spaces when customer name does not comes
(L1 is customer name's cell)

i want to get rid of those empty cells which comes because of "" . so how do i do this?

[Colin Legg]

Welcome to the forum.

Are you entering =IF(B3:B13=$L$1,A3:A13,"") into an array range? I think it would help us if you mocked up an example spreadsheet and attached it to the thread for us to see. If you're asking for what I think you're asking for then, yes, it is possible to do it with formulas but it is not simple and there are better alternatives. I'll reserve my recommendation until I'm 100% clear on exactly what you need.

[nicholes]

Originally Posted by Colin Legg

Welcome to the forum.

Are you entering =IF(B3:B13=$L$1,A3:A13,"") into an array range? I think it would help us if you mocked up an example spreadsheet and attached it to the thread for us to see. If you're asking for what I think you're asking for then, yes, it is possible to do it with formulas but it is not simple and there are better alternatives. I'll reserve my recommendation until I'm 100% clear on exactly what you need.

ok i have attached a file and here is what i want...

i want to get rid of those blank spaces (in E4,E5) is there any easy way that i can understand too?

EDIT:-can i ask one more thing in in same thread(off topic for this thread)

how do i fill same data in other cell?

for example if i type date in A1 and i type price in B1 .. now i want this enter of A1 and B1 should also go automatically in sheet 2(in A1 B1) and in sheet3 (A1 B1) as well. HOW TO?

[caholmes]

Hi nicholes,

why don't you just filter the data using an autofilter?

[clanger32]

I might be missing something, but it depends what you DO want in the cells E4 and E5. probably telling you what you already know, but whatever is between the speechmarks in the formula for the "false" argument is what will appear in the cell. So if you wanted for example the word null to appear in that range if it wasn't the client, you'd simply put "null" in place of ""

That said, if you're looking to do one persons credit account, why would you have other peoples data in the sheet? And if you do need a range of data, then certainly filter seems a good option....